My Stuff
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
-
Re: Entity Table Save Search - surface Entity Type
Hi @KNason76 , The entity type field may not be an exposed field when doing an entity search. However, you may try to use the System Notes.. Old Value field and create a formula from it. You may try …6 -
Re: Analytics Yearly Overlay
Glad it worked for you :) Yep, its sad that it is not utilizing the stacked features though.1 -
Re: Saved search grouped by period rather than invoice transaction date
Hi @User_SP0KO, Can you try these Formula (Numeric) values instead? DECODE (to_char({today},'MM') - (to_char(to_date({postingperiod}, 'MM.YYYY'), 'MM')) + 12 * (to_char(…3 -
Re: SQL waaaaay beyond my ability for date range
Hi @HertsChris , Welcome to this community. I am not exactly sure how your N is computed, but if you only need a simple formula, you may start with this: Formula (Numeric) = CASE WHEN (to_char(LAST_D…1 -
Re: Global Search cannot find customers with space in their name
Hi @User_YYMQK, Can you confirm if the 'GLOBAL SEARCH AUTO SUGGEST' is enabled on your Set Preferences page? Also, can you try the following parameters and see if it works for "J J Con…2
